<?php
//======================================================================================
//
// Function: Get hub_webtrn => DATA-HUB - HUB_WEBTRN
//
// Programmer: AR
// Date : 2024-07-19
//
// Copyright Reeft A/S (c) - 2024
//======================================================================================
//======================================================================================
// General config
//======================================================================================
include "config/config.php";
//======================================================================================
// Get input
//======================================================================================
if (isset($_REQUEST["hub_webnam"])) {
$hub_webnam = strtoupper($_REQUEST["hub_webnam"]);
} else {
$hub_webnam = 'HUB_LOG';
}
if (isset($_REQUEST["timesort"])) {
$timesort = strtoupper($_REQUEST["timesort"]);
} else {
$timesort = 'DESC';
}
if (isset($_REQUEST["fromdate"])) {
$fromdate = strtoupper($_REQUEST["fromdate"]);
} else {
$fromdate = '';
}
if (isset($_REQUEST["fromtime"])) {
$fromtime = strtoupper($_REQUEST["fromtime"]);
} else {
$fromtime = '';
}
if (isset($_REQUEST["todate"])) {
$todate = strtoupper($_REQUEST["todate"]);
} else {
$todate = '';
}
if (isset($_REQUEST["totime"])) {
$totime = strtoupper($_REQUEST["totime"]);
} else {
$totime = '';
}
if (isset($_REQUEST["myPageGoTo"])) {
$myPageGoTo = $_REQUEST["myPageGoTo"];
} else {
$myPageGoTo = 0;
}
if (isset($_REQUEST["myOffSet"])) {
$myOffSet = $_REQUEST["myOffSet"];
} else {
$myOffSet = 0;
}
if (isset($_REQUEST["myPageSize"])) {
$myPageSize = $_REQUEST["myPageSize"];
} else {
$myPageSize = 0;
}
if (isset($_REQUEST["search_arg"])) {
$search_arg = $_REQUEST["search_arg"];
} else {
$search_arg = '';
}
//$search_arg = urldecode($search_arg);
$search_arg = str_replace(' ', "|", $search_arg);
//======================================================================================
// Get input
//======================================================================================
//======================================================================================
// Get session variables
//======================================================================================
include "include/getsession.php";
//======================================================================================
// Set language
//======================================================================================
include "include/set_language.php";
//======================================================================================
// Connect to SQLite database in file
//======================================================================================
$entries_found = 0;
$returnCode = '99';
$returnMsg = 'No data found';
$currentDate = date('Y-m-d');
$currentTime = date('H:i:s');
//======================================================================================
// Set header
//======================================================================================
header('Content-Type: application/json;charset=utf-8');
//======================================================================================
// Get time stamp
//======================================================================================
$timeStamp = '';
if ( $timeStamp == '' ) {
$now = DateTime::createFromFormat('U.u', number_format(microtime(true), 6, '.', ''));
$timeStamp = $now->format("Y-m-d H:i:s");
}
$data = array(
"timestamp" => $timeStamp,
"timesort" => $timesort,
"hub_webnam" => $hub_webnam,
"myPageGoTo" => $myPageGoTo,
"myOffSet" => $myOffSet,
"myPageSize" => $myPageSize
);
if (trim($fromdate) != '') $data["fromdate"] = $fromdate;
if (trim($fromtime) != '') $data["fromtime"] = $fromtime;
if (trim($todate) != '') $data["todate"] = $todate;
if (trim($totime) != '') $data["totime"] = $totime;
// print_r($data);
// echo $search_arg;
// exit;
//======================================================================================
// Make call to API somewhere
//======================================================================================
header('Content-Type: application/json;charset=utf-8');
$jsonData = json_encode($data);
//header('Content-Type: application/json');
$json_pretty = json_encode(json_decode($jsonData), JSON_PRETTY_PRINT);
// echo $json_pretty;
// echo "<br>";
// echo $url;
$headers = array(
"Content-type: Content-Type:application/json",
"User-Agent: DATA-HUB 1.0",
"APIKEY: $DFT_API_KEY"
);
$parms = '?'
. 'timesort=' . trim( $timesort )
. '&hub_webnam=' . $hub_webnam
. '&myPageGoTo=' . $myPageGoTo
. '&myOffSet=' . $myOffSet
. '&myPageSize=' . $myPageSize
. '&mySearchArg=' . $search_arg
;
if (trim($fromdate) != '') $parms .= '&fromdate=' . trim( $fromdate );
if (trim($fromtime) != '') $parms .= '&fromtime=' . trim( $fromtime );
if (trim($todate) != '') $parms .= '&todate=' . trim( $todate );
if (trim($totime) != '') $parms .= '&totime=' . trim( $totime );
// Set URL
$url = $DFT_WEBSERVICE_URL_DATAHUB . '/' . 'HUB_WEBTRN';
// Add parms
$url = $url . $parms;
$mySession = print_r($jsonData, true);
//echo $url;
// Create a new cURL resource
$ch = curl_init($url);
// Attach encoded JSON string to the POST fields
curl_setopt($ch, CURLOPT_POSTFIELDS, $jsonData);
// Set the content type to application/json
//curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type:application/json'));
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers );
// Return response instead of outputting
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POST, false);
//curl_setopt( $ch, CURLOPT_CUSTOMREQUEST, 'POST' );
curl_setopt($ch, CURLOPT_HEADER, false); // we do not need headers
curl_setopt($ch, CURLOPT_NOBODY, false); // we don't need body
// Execute the GET request
$result = curl_exec($ch);
$ary = curl_getinfo($ch);
// Close cURL resource
curl_close($ch);
//print_r($ary);
print_r($result);
?>